place_text_property¶| pk_named_place_text_property | property_type | lang_iso_code | text | notes | fk_named_place | creator | creation_time | modifier | modification_time | concat_nptp | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 3254 | 23750.0 | notice | fra | Chef-lieu du canton au 1er janvier 2009 | NaN | 88581.0 | 4.0 | 2009-11-16 10:05:21.000 | 4.0 | 2014-02-06 12:19:14 | NPTP23750 |
| 17138 | 37696.0 | complment | fra | Russia | NaN | 8977.0 | 3.0 | 2007-07-20 16:47:45.000 | 3.0 | 2014-02-06 12:19:14 | NPTP37696 |
| 5104 | 25647.0 | complment | fra | 8226107 | NaN | 86383.0 | 4.0 | 2009-11-16 10:05:11.000 | 4.0 | 2014-02-06 12:19:14 | NPTP25647 |
| 3124 | 23622.0 | notice | fra | Chef-lieu du canton au 1er janvier 2009 | NaN | 88453.0 | 4.0 | 2009-11-16 10:05:20.000 | 4.0 | 2014-02-06 12:19:14 | NPTP23622 |
| 9856 | 30401.0 | complment | fra | France | NaN | 1674.0 | 3.0 | 2007-07-20 16:47:45.000 | 3.0 | 2014-02-06 12:19:14 | NPTP30401 |
Columns contain: Total number of rows: 26549 - "pk_named_place_text_property": 0.00% empty - 26549 (100.00%) uniques (eg: 41200.0; 20543.0; 20545.0) - "property_type": 0.00% empty - 2 ( 0.01%) uniques (eg: notice; complment) - "text": 0.00% empty - 9221 ( 34.73%) uniques (eg: Saarlouis; Salvador d...; / Capitale...) - "fk_named_place": 0.00% empty - 22432 ( 84.49%) uniques (eg: 121395.0; 59.0; 3697.0) - "creation_time": 0.00% empty - 1570 ( 5.91%) uniques (eg: 2014-01-30...; 2007-07-20...; 2009-08-21...) - "concat_nptp": 0.00% empty - 26549 (100.00%) uniques (eg: NPTP41200; NPTP20543; NPTP20545) - "creator": 0.00% empty - 42 ( 0.16%) uniques (eg: 67.0; 3.0; 4.0) - "modifier": 0.00% empty - 41 ( 0.15%) uniques (eg: 67.0; 3.0; 4.0) - "lang_iso_code": 0.06% empty - 4 ( 0.02%) uniques (eg: fra; ita; nan) - "modification_time": 3.94% empty - 218 ( 0.82%) uniques (eg: 2014-02-06...; nan; 2017-09-05...) - "notes": 99.60% empty - 26 ( 0.10%) uniques (eg: nan; Sourcehttp...; Source :ht...)
Here we will report the analysis of interesting information found on different columns. They are not exhaustive.
All HTML tags, non ASCII chars and new line are removed.